package cai.dlt.dao.impl;

import java.util.List;

import search.dao.Impl.UniversalDaoImpl;
import cai.dlt.dao.IDltDao;

public class DltDao extends UniversalDaoImpl implements IDltDao {

	
	public List getB1(String dateid) {
		String sql="select b1,count(b1) b_sum from dlt where dateid='"+dateid+"' group by b1 order by b1";
		return queryForList(sql);
	}

	
	public List getB2(String dateid) {
		String sql="select b2,count(b2) b_sum from dlt where dateid='"+dateid+"' group by b2 order by b2";
		return queryForList(sql);
	}

	
	public List getR1(String dateid) {
		String sql="select r1,count(r1) r1_sum from dlt where dateid='"+dateid+"' group by r1 order by r1";
		return queryForList(sql);
	}

	public List getR2(String dateid) {
		String sql="select r2,count(r2) r2_sum from dlt where dateid='"+dateid+"' group by r2 order by r2";
		return queryForList(sql);
	}

	public List getR3(String dateid) {
		String sql="select r3,count(r3) r3_sum from dlt where dateid='"+dateid+"' group by r3 order by r3";
		return queryForList(sql);
	}

	public List getR4(String dateid) {
		String sql="select r4,count(r4) r4_sum from dlt where dateid='"+dateid+"' group by r4 order by r4";
		return queryForList(sql);
	}

	public List getR5(String dateid) {
		String sql="select r5,count(r5) r5_sum from dlt where dateid='"+dateid+"' group by r5 order by r5";
		return queryForList(sql);
	}

}
